package com.ecoolex.chinadutyfree.retailer.entity;

import com.ecoolex.framework.common.annotation.Description;
import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import org.springframework.lang.NonNull;

public class DirectMailGoodsOrderAfterSalesExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    protected Integer offset;

    protected Integer rows;

    public DirectMailGoodsOrderAfterSalesExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public DirectMailGoodsOrderAfterSalesExample orderBy(String orderByClause) {
        this.setOrderByClause(orderByClause);
        return this;
    }

    public DirectMailGoodsOrderAfterSalesExample orderBy(String ... orderByClauses) {
        StringBuffer sb = new StringBuffer();
        for (int i = 0; i < orderByClauses.length; i++) {
            sb.append(orderByClauses[i]);
            if (i < orderByClauses.length - 1) {
                sb.append(" , ");
            }
        }
        this.setOrderByClause(sb.toString());
        return this;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria(this);
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
        rows = null;
        offset = null;
    }

    public static Criteria newAndCreateCriteria() {
        DirectMailGoodsOrderAfterSalesExample example = new DirectMailGoodsOrderAfterSalesExample();
        return example.createCriteria();
    }

    public DirectMailGoodsOrderAfterSalesExample when(boolean condition, IExampleWhen then) {
        if (condition) {
            then.example(this);
        }
        return this;
    }

    public DirectMailGoodsOrderAfterSalesExample when(boolean condition, IExampleWhen then, IExampleWhen otherwise) {
        if (condition) {
            then.example(this);
        } else {
            otherwise.example(this);
        }
        return this;
    }

    public void setOffset(Integer offset) {
        this.offset = offset;
    }

    public Integer getOffset() {
        return this.offset;
    }

    public void setRows(Integer rows) {
        this.rows = rows;
    }

    public Integer getRows() {
        return this.rows;
    }

    public DirectMailGoodsOrderAfterSalesExample limit(Integer rows) {
        this.rows = rows;
        return this;
    }

    public DirectMailGoodsOrderAfterSalesExample limit(Integer offset, Integer rows) {
        this.offset = offset;
        this.rows = rows;
        return this;
    }

    public DirectMailGoodsOrderAfterSalesExample page(Integer page, Integer pageSize) {
        this.offset = page * pageSize;
        this.rows = pageSize;
        return this;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andAfterSalesIdIsNull() {
            addCriterion("directmailgoodsorderaftersales.AfterSalesId is null");
            return (Criteria) this;
        }

        public Criteria andAfterSalesIdIsNotNull() {
            addCriterion("directmailgoodsorderaftersales.AfterSalesId is not null");
            return (Criteria) this;
        }

        public Criteria andAfterSalesIdEqualTo(Integer value) {
            addCriterion("directmailgoodsorderaftersales.AfterSalesId =", value, "afterSalesId");
            return (Criteria) this;
        }

        public Criteria andAfterSalesIdEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.AfterSalesId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAfterSalesIdNotEqualTo(Integer value) {
            addCriterion("directmailgoodsorderaftersales.AfterSalesId <>", value, "afterSalesId");
            return (Criteria) this;
        }

        public Criteria andAfterSalesIdNotEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.AfterSalesId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAfterSalesIdGreaterThan(Integer value) {
            addCriterion("directmailgoodsorderaftersales.AfterSalesId >", value, "afterSalesId");
            return (Criteria) this;
        }

        public Criteria andAfterSalesIdGreaterThanColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.AfterSalesId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAfterSalesIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsorderaftersales.AfterSalesId >=", value, "afterSalesId");
            return (Criteria) this;
        }

        public Criteria andAfterSalesIdGreaterThanOrEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.AfterSalesId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAfterSalesIdLessThan(Integer value) {
            addCriterion("directmailgoodsorderaftersales.AfterSalesId <", value, "afterSalesId");
            return (Criteria) this;
        }

        public Criteria andAfterSalesIdLessThanColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.AfterSalesId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAfterSalesIdLessThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsorderaftersales.AfterSalesId <=", value, "afterSalesId");
            return (Criteria) this;
        }

        public Criteria andAfterSalesIdLessThanOrEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.AfterSalesId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAfterSalesIdIn(List<Integer> values) {
            addCriterion("directmailgoodsorderaftersales.AfterSalesId in", values, "afterSalesId");
            return (Criteria) this;
        }

        public Criteria andAfterSalesIdNotIn(List<Integer> values) {
            addCriterion("directmailgoodsorderaftersales.AfterSalesId not in", values, "afterSalesId");
            return (Criteria) this;
        }

        public Criteria andAfterSalesIdBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsorderaftersales.AfterSalesId between", value1, value2, "afterSalesId");
            return (Criteria) this;
        }

        public Criteria andAfterSalesIdNotBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsorderaftersales.AfterSalesId not between", value1, value2, "afterSalesId");
            return (Criteria) this;
        }

        public Criteria andAfterSalesNoIsNull() {
            addCriterion("directmailgoodsorderaftersales.AfterSalesNo is null");
            return (Criteria) this;
        }

        public Criteria andAfterSalesNoIsNotNull() {
            addCriterion("directmailgoodsorderaftersales.AfterSalesNo is not null");
            return (Criteria) this;
        }

        public Criteria andAfterSalesNoEqualTo(String value) {
            addCriterion("directmailgoodsorderaftersales.AfterSalesNo =", value, "afterSalesNo");
            return (Criteria) this;
        }

        public Criteria andAfterSalesNoEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.AfterSalesNo = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAfterSalesNoNotEqualTo(String value) {
            addCriterion("directmailgoodsorderaftersales.AfterSalesNo <>", value, "afterSalesNo");
            return (Criteria) this;
        }

        public Criteria andAfterSalesNoNotEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.AfterSalesNo <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAfterSalesNoGreaterThan(String value) {
            addCriterion("directmailgoodsorderaftersales.AfterSalesNo >", value, "afterSalesNo");
            return (Criteria) this;
        }

        public Criteria andAfterSalesNoGreaterThanColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.AfterSalesNo > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAfterSalesNoGreaterThanOrEqualTo(String value) {
            addCriterion("directmailgoodsorderaftersales.AfterSalesNo >=", value, "afterSalesNo");
            return (Criteria) this;
        }

        public Criteria andAfterSalesNoGreaterThanOrEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.AfterSalesNo >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAfterSalesNoLessThan(String value) {
            addCriterion("directmailgoodsorderaftersales.AfterSalesNo <", value, "afterSalesNo");
            return (Criteria) this;
        }

        public Criteria andAfterSalesNoLessThanColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.AfterSalesNo < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAfterSalesNoLessThanOrEqualTo(String value) {
            addCriterion("directmailgoodsorderaftersales.AfterSalesNo <=", value, "afterSalesNo");
            return (Criteria) this;
        }

        public Criteria andAfterSalesNoLessThanOrEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.AfterSalesNo <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAfterSalesNoLike(String value) {
            addCriterion("directmailgoodsorderaftersales.AfterSalesNo like", value, "afterSalesNo");
            return (Criteria) this;
        }

        public Criteria andAfterSalesNoNotLike(String value) {
            addCriterion("directmailgoodsorderaftersales.AfterSalesNo not like", value, "afterSalesNo");
            return (Criteria) this;
        }

        public Criteria andAfterSalesNoIn(List<String> values) {
            addCriterion("directmailgoodsorderaftersales.AfterSalesNo in", values, "afterSalesNo");
            return (Criteria) this;
        }

        public Criteria andAfterSalesNoNotIn(List<String> values) {
            addCriterion("directmailgoodsorderaftersales.AfterSalesNo not in", values, "afterSalesNo");
            return (Criteria) this;
        }

        public Criteria andAfterSalesNoBetween(String value1, String value2) {
            addCriterion("directmailgoodsorderaftersales.AfterSalesNo between", value1, value2, "afterSalesNo");
            return (Criteria) this;
        }

        public Criteria andAfterSalesNoNotBetween(String value1, String value2) {
            addCriterion("directmailgoodsorderaftersales.AfterSalesNo not between", value1, value2, "afterSalesNo");
            return (Criteria) this;
        }

        public Criteria andOrderIdIsNull() {
            addCriterion("directmailgoodsorderaftersales.OrderId is null");
            return (Criteria) this;
        }

        public Criteria andOrderIdIsNotNull() {
            addCriterion("directmailgoodsorderaftersales.OrderId is not null");
            return (Criteria) this;
        }

        public Criteria andOrderIdEqualTo(Integer value) {
            addCriterion("directmailgoodsorderaftersales.OrderId =", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.OrderId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderIdNotEqualTo(Integer value) {
            addCriterion("directmailgoodsorderaftersales.OrderId <>", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.OrderId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThan(Integer value) {
            addCriterion("directmailgoodsorderaftersales.OrderId >", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThanColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.OrderId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsorderaftersales.OrderId >=", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThanOrEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.OrderId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThan(Integer value) {
            addCriterion("directmailgoodsorderaftersales.OrderId <", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThanColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.OrderId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsorderaftersales.OrderId <=", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThanOrEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.OrderId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderIdIn(List<Integer> values) {
            addCriterion("directmailgoodsorderaftersales.OrderId in", values, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotIn(List<Integer> values) {
            addCriterion("directmailgoodsorderaftersales.OrderId not in", values, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsorderaftersales.OrderId between", value1, value2, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsorderaftersales.OrderId not between", value1, value2, "orderId");
            return (Criteria) this;
        }

        public Criteria andUserIdIsNull() {
            addCriterion("directmailgoodsorderaftersales.UserId is null");
            return (Criteria) this;
        }

        public Criteria andUserIdIsNotNull() {
            addCriterion("directmailgoodsorderaftersales.UserId is not null");
            return (Criteria) this;
        }

        public Criteria andUserIdEqualTo(Integer value) {
            addCriterion("directmailgoodsorderaftersales.UserId =", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.UserId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserIdNotEqualTo(Integer value) {
            addCriterion("directmailgoodsorderaftersales.UserId <>", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.UserId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThan(Integer value) {
            addCriterion("directmailgoodsorderaftersales.UserId >", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThanColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.UserId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsorderaftersales.UserId >=", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThanOrEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.UserId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserIdLessThan(Integer value) {
            addCriterion("directmailgoodsorderaftersales.UserId <", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLessThanColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.UserId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserIdLessThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsorderaftersales.UserId <=", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLessThanOrEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.UserId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserIdIn(List<Integer> values) {
            addCriterion("directmailgoodsorderaftersales.UserId in", values, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotIn(List<Integer> values) {
            addCriterion("directmailgoodsorderaftersales.UserId not in", values, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsorderaftersales.UserId between", value1, value2, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsorderaftersales.UserId not between", value1, value2, "userId");
            return (Criteria) this;
        }

        public Criteria andTypeIsNull() {
            addCriterion("directmailgoodsorderaftersales.`Type` is null");
            return (Criteria) this;
        }

        public Criteria andTypeIsNotNull() {
            addCriterion("directmailgoodsorderaftersales.`Type` is not null");
            return (Criteria) this;
        }

        public Criteria andTypeEqualTo(Integer value) {
            addCriterion("directmailgoodsorderaftersales.`Type` =", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.`Type` = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTypeNotEqualTo(Integer value) {
            addCriterion("directmailgoodsorderaftersales.`Type` <>", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.`Type` <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTypeGreaterThan(Integer value) {
            addCriterion("directmailgoodsorderaftersales.`Type` >", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeGreaterThanColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.`Type` > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsorderaftersales.`Type` >=", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeGreaterThanOrEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.`Type` >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTypeLessThan(Integer value) {
            addCriterion("directmailgoodsorderaftersales.`Type` <", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeLessThanColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.`Type` < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTypeLessThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsorderaftersales.`Type` <=", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeLessThanOrEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.`Type` <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTypeIn(List<Integer> values) {
            addCriterion("directmailgoodsorderaftersales.`Type` in", values, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotIn(List<Integer> values) {
            addCriterion("directmailgoodsorderaftersales.`Type` not in", values, "type");
            return (Criteria) this;
        }

        public Criteria andTypeBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsorderaftersales.`Type` between", value1, value2, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsorderaftersales.`Type` not between", value1, value2, "type");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("directmailgoodsorderaftersales.`Status` is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("directmailgoodsorderaftersales.`Status` is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(Integer value) {
            addCriterion("directmailgoodsorderaftersales.`Status` =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.`Status` = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(Integer value) {
            addCriterion("directmailgoodsorderaftersales.`Status` <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.`Status` <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(Integer value) {
            addCriterion("directmailgoodsorderaftersales.`Status` >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.`Status` > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsorderaftersales.`Status` >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.`Status` >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(Integer value) {
            addCriterion("directmailgoodsorderaftersales.`Status` <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.`Status` < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsorderaftersales.`Status` <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.`Status` <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<Integer> values) {
            addCriterion("directmailgoodsorderaftersales.`Status` in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<Integer> values) {
            addCriterion("directmailgoodsorderaftersales.`Status` not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsorderaftersales.`Status` between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsorderaftersales.`Status` not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andReasonIsNull() {
            addCriterion("directmailgoodsorderaftersales.Reason is null");
            return (Criteria) this;
        }

        public Criteria andReasonIsNotNull() {
            addCriterion("directmailgoodsorderaftersales.Reason is not null");
            return (Criteria) this;
        }

        public Criteria andReasonEqualTo(String value) {
            addCriterion("directmailgoodsorderaftersales.Reason =", value, "reason");
            return (Criteria) this;
        }

        public Criteria andReasonEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.Reason = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andReasonNotEqualTo(String value) {
            addCriterion("directmailgoodsorderaftersales.Reason <>", value, "reason");
            return (Criteria) this;
        }

        public Criteria andReasonNotEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.Reason <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andReasonGreaterThan(String value) {
            addCriterion("directmailgoodsorderaftersales.Reason >", value, "reason");
            return (Criteria) this;
        }

        public Criteria andReasonGreaterThanColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.Reason > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andReasonGreaterThanOrEqualTo(String value) {
            addCriterion("directmailgoodsorderaftersales.Reason >=", value, "reason");
            return (Criteria) this;
        }

        public Criteria andReasonGreaterThanOrEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.Reason >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andReasonLessThan(String value) {
            addCriterion("directmailgoodsorderaftersales.Reason <", value, "reason");
            return (Criteria) this;
        }

        public Criteria andReasonLessThanColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.Reason < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andReasonLessThanOrEqualTo(String value) {
            addCriterion("directmailgoodsorderaftersales.Reason <=", value, "reason");
            return (Criteria) this;
        }

        public Criteria andReasonLessThanOrEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.Reason <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andReasonLike(String value) {
            addCriterion("directmailgoodsorderaftersales.Reason like", value, "reason");
            return (Criteria) this;
        }

        public Criteria andReasonNotLike(String value) {
            addCriterion("directmailgoodsorderaftersales.Reason not like", value, "reason");
            return (Criteria) this;
        }

        public Criteria andReasonIn(List<String> values) {
            addCriterion("directmailgoodsorderaftersales.Reason in", values, "reason");
            return (Criteria) this;
        }

        public Criteria andReasonNotIn(List<String> values) {
            addCriterion("directmailgoodsorderaftersales.Reason not in", values, "reason");
            return (Criteria) this;
        }

        public Criteria andReasonBetween(String value1, String value2) {
            addCriterion("directmailgoodsorderaftersales.Reason between", value1, value2, "reason");
            return (Criteria) this;
        }

        public Criteria andReasonNotBetween(String value1, String value2) {
            addCriterion("directmailgoodsorderaftersales.Reason not between", value1, value2, "reason");
            return (Criteria) this;
        }

        public Criteria andEvidenceImageIsNull() {
            addCriterion("directmailgoodsorderaftersales.EvidenceImage is null");
            return (Criteria) this;
        }

        public Criteria andEvidenceImageIsNotNull() {
            addCriterion("directmailgoodsorderaftersales.EvidenceImage is not null");
            return (Criteria) this;
        }

        public Criteria andEvidenceImageEqualTo(String value) {
            addCriterion("directmailgoodsorderaftersales.EvidenceImage =", value, "evidenceImage");
            return (Criteria) this;
        }

        public Criteria andEvidenceImageEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.EvidenceImage = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andEvidenceImageNotEqualTo(String value) {
            addCriterion("directmailgoodsorderaftersales.EvidenceImage <>", value, "evidenceImage");
            return (Criteria) this;
        }

        public Criteria andEvidenceImageNotEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.EvidenceImage <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andEvidenceImageGreaterThan(String value) {
            addCriterion("directmailgoodsorderaftersales.EvidenceImage >", value, "evidenceImage");
            return (Criteria) this;
        }

        public Criteria andEvidenceImageGreaterThanColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.EvidenceImage > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andEvidenceImageGreaterThanOrEqualTo(String value) {
            addCriterion("directmailgoodsorderaftersales.EvidenceImage >=", value, "evidenceImage");
            return (Criteria) this;
        }

        public Criteria andEvidenceImageGreaterThanOrEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.EvidenceImage >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andEvidenceImageLessThan(String value) {
            addCriterion("directmailgoodsorderaftersales.EvidenceImage <", value, "evidenceImage");
            return (Criteria) this;
        }

        public Criteria andEvidenceImageLessThanColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.EvidenceImage < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andEvidenceImageLessThanOrEqualTo(String value) {
            addCriterion("directmailgoodsorderaftersales.EvidenceImage <=", value, "evidenceImage");
            return (Criteria) this;
        }

        public Criteria andEvidenceImageLessThanOrEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.EvidenceImage <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andEvidenceImageLike(String value) {
            addCriterion("directmailgoodsorderaftersales.EvidenceImage like", value, "evidenceImage");
            return (Criteria) this;
        }

        public Criteria andEvidenceImageNotLike(String value) {
            addCriterion("directmailgoodsorderaftersales.EvidenceImage not like", value, "evidenceImage");
            return (Criteria) this;
        }

        public Criteria andEvidenceImageIn(List<String> values) {
            addCriterion("directmailgoodsorderaftersales.EvidenceImage in", values, "evidenceImage");
            return (Criteria) this;
        }

        public Criteria andEvidenceImageNotIn(List<String> values) {
            addCriterion("directmailgoodsorderaftersales.EvidenceImage not in", values, "evidenceImage");
            return (Criteria) this;
        }

        public Criteria andEvidenceImageBetween(String value1, String value2) {
            addCriterion("directmailgoodsorderaftersales.EvidenceImage between", value1, value2, "evidenceImage");
            return (Criteria) this;
        }

        public Criteria andEvidenceImageNotBetween(String value1, String value2) {
            addCriterion("directmailgoodsorderaftersales.EvidenceImage not between", value1, value2, "evidenceImage");
            return (Criteria) this;
        }

        public Criteria andAuditOpinionIsNull() {
            addCriterion("directmailgoodsorderaftersales.AuditOpinion is null");
            return (Criteria) this;
        }

        public Criteria andAuditOpinionIsNotNull() {
            addCriterion("directmailgoodsorderaftersales.AuditOpinion is not null");
            return (Criteria) this;
        }

        public Criteria andAuditOpinionEqualTo(String value) {
            addCriterion("directmailgoodsorderaftersales.AuditOpinion =", value, "auditOpinion");
            return (Criteria) this;
        }

        public Criteria andAuditOpinionEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.AuditOpinion = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAuditOpinionNotEqualTo(String value) {
            addCriterion("directmailgoodsorderaftersales.AuditOpinion <>", value, "auditOpinion");
            return (Criteria) this;
        }

        public Criteria andAuditOpinionNotEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.AuditOpinion <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAuditOpinionGreaterThan(String value) {
            addCriterion("directmailgoodsorderaftersales.AuditOpinion >", value, "auditOpinion");
            return (Criteria) this;
        }

        public Criteria andAuditOpinionGreaterThanColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.AuditOpinion > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAuditOpinionGreaterThanOrEqualTo(String value) {
            addCriterion("directmailgoodsorderaftersales.AuditOpinion >=", value, "auditOpinion");
            return (Criteria) this;
        }

        public Criteria andAuditOpinionGreaterThanOrEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.AuditOpinion >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAuditOpinionLessThan(String value) {
            addCriterion("directmailgoodsorderaftersales.AuditOpinion <", value, "auditOpinion");
            return (Criteria) this;
        }

        public Criteria andAuditOpinionLessThanColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.AuditOpinion < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAuditOpinionLessThanOrEqualTo(String value) {
            addCriterion("directmailgoodsorderaftersales.AuditOpinion <=", value, "auditOpinion");
            return (Criteria) this;
        }

        public Criteria andAuditOpinionLessThanOrEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.AuditOpinion <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAuditOpinionLike(String value) {
            addCriterion("directmailgoodsorderaftersales.AuditOpinion like", value, "auditOpinion");
            return (Criteria) this;
        }

        public Criteria andAuditOpinionNotLike(String value) {
            addCriterion("directmailgoodsorderaftersales.AuditOpinion not like", value, "auditOpinion");
            return (Criteria) this;
        }

        public Criteria andAuditOpinionIn(List<String> values) {
            addCriterion("directmailgoodsorderaftersales.AuditOpinion in", values, "auditOpinion");
            return (Criteria) this;
        }

        public Criteria andAuditOpinionNotIn(List<String> values) {
            addCriterion("directmailgoodsorderaftersales.AuditOpinion not in", values, "auditOpinion");
            return (Criteria) this;
        }

        public Criteria andAuditOpinionBetween(String value1, String value2) {
            addCriterion("directmailgoodsorderaftersales.AuditOpinion between", value1, value2, "auditOpinion");
            return (Criteria) this;
        }

        public Criteria andAuditOpinionNotBetween(String value1, String value2) {
            addCriterion("directmailgoodsorderaftersales.AuditOpinion not between", value1, value2, "auditOpinion");
            return (Criteria) this;
        }

        public Criteria andRefundPriceIsNull() {
            addCriterion("directmailgoodsorderaftersales.RefundPrice is null");
            return (Criteria) this;
        }

        public Criteria andRefundPriceIsNotNull() {
            addCriterion("directmailgoodsorderaftersales.RefundPrice is not null");
            return (Criteria) this;
        }

        public Criteria andRefundPriceEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorderaftersales.RefundPrice =", value, "refundPrice");
            return (Criteria) this;
        }

        public Criteria andRefundPriceEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.RefundPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRefundPriceNotEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorderaftersales.RefundPrice <>", value, "refundPrice");
            return (Criteria) this;
        }

        public Criteria andRefundPriceNotEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.RefundPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRefundPriceGreaterThan(BigDecimal value) {
            addCriterion("directmailgoodsorderaftersales.RefundPrice >", value, "refundPrice");
            return (Criteria) this;
        }

        public Criteria andRefundPriceGreaterThanColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.RefundPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRefundPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorderaftersales.RefundPrice >=", value, "refundPrice");
            return (Criteria) this;
        }

        public Criteria andRefundPriceGreaterThanOrEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.RefundPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRefundPriceLessThan(BigDecimal value) {
            addCriterion("directmailgoodsorderaftersales.RefundPrice <", value, "refundPrice");
            return (Criteria) this;
        }

        public Criteria andRefundPriceLessThanColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.RefundPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRefundPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorderaftersales.RefundPrice <=", value, "refundPrice");
            return (Criteria) this;
        }

        public Criteria andRefundPriceLessThanOrEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.RefundPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRefundPriceIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsorderaftersales.RefundPrice in", values, "refundPrice");
            return (Criteria) this;
        }

        public Criteria andRefundPriceNotIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsorderaftersales.RefundPrice not in", values, "refundPrice");
            return (Criteria) this;
        }

        public Criteria andRefundPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsorderaftersales.RefundPrice between", value1, value2, "refundPrice");
            return (Criteria) this;
        }

        public Criteria andRefundPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsorderaftersales.RefundPrice not between", value1, value2, "refundPrice");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNull() {
            addCriterion("directmailgoodsorderaftersales.Deleted is null");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNotNull() {
            addCriterion("directmailgoodsorderaftersales.Deleted is not null");
            return (Criteria) this;
        }

        public Criteria andDeletedEqualTo(Boolean value) {
            addCriterion("directmailgoodsorderaftersales.Deleted =", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.Deleted = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedNotEqualTo(Boolean value) {
            addCriterion("directmailgoodsorderaftersales.Deleted <>", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.Deleted <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThan(Boolean value) {
            addCriterion("directmailgoodsorderaftersales.Deleted >", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.Deleted > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanOrEqualTo(Boolean value) {
            addCriterion("directmailgoodsorderaftersales.Deleted >=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanOrEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.Deleted >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedLessThan(Boolean value) {
            addCriterion("directmailgoodsorderaftersales.Deleted <", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.Deleted < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanOrEqualTo(Boolean value) {
            addCriterion("directmailgoodsorderaftersales.Deleted <=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanOrEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.Deleted <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedIn(List<Boolean> values) {
            addCriterion("directmailgoodsorderaftersales.Deleted in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotIn(List<Boolean> values) {
            addCriterion("directmailgoodsorderaftersales.Deleted not in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedBetween(Boolean value1, Boolean value2) {
            addCriterion("directmailgoodsorderaftersales.Deleted between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotBetween(Boolean value1, Boolean value2) {
            addCriterion("directmailgoodsorderaftersales.Deleted not between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNull() {
            addCriterion("directmailgoodsorderaftersales.`CreateUser` is null");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNotNull() {
            addCriterion("directmailgoodsorderaftersales.`CreateUser` is not null");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualTo(String value) {
            addCriterion("directmailgoodsorderaftersales.`CreateUser` =", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.`CreateUser` = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualTo(String value) {
            addCriterion("directmailgoodsorderaftersales.`CreateUser` <>", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.`CreateUser` <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThan(String value) {
            addCriterion("directmailgoodsorderaftersales.`CreateUser` >", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.`CreateUser` > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualTo(String value) {
            addCriterion("directmailgoodsorderaftersales.`CreateUser` >=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.`CreateUser` >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThan(String value) {
            addCriterion("directmailgoodsorderaftersales.`CreateUser` <", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.`CreateUser` < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualTo(String value) {
            addCriterion("directmailgoodsorderaftersales.`CreateUser` <=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.`CreateUser` <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLike(String value) {
            addCriterion("directmailgoodsorderaftersales.`CreateUser` like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotLike(String value) {
            addCriterion("directmailgoodsorderaftersales.`CreateUser` not like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserIn(List<String> values) {
            addCriterion("directmailgoodsorderaftersales.`CreateUser` in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotIn(List<String> values) {
            addCriterion("directmailgoodsorderaftersales.`CreateUser` not in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserBetween(String value1, String value2) {
            addCriterion("directmailgoodsorderaftersales.`CreateUser` between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotBetween(String value1, String value2) {
            addCriterion("directmailgoodsorderaftersales.`CreateUser` not between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("directmailgoodsorderaftersales.CreateTime is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("directmailgoodsorderaftersales.CreateTime is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("directmailgoodsorderaftersales.CreateTime =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.CreateTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("directmailgoodsorderaftersales.CreateTime <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.CreateTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("directmailgoodsorderaftersales.CreateTime >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.CreateTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("directmailgoodsorderaftersales.CreateTime >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.CreateTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("directmailgoodsorderaftersales.CreateTime <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.CreateTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("directmailgoodsorderaftersales.CreateTime <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.CreateTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("directmailgoodsorderaftersales.CreateTime in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("directmailgoodsorderaftersales.CreateTime not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("directmailgoodsorderaftersales.CreateTime between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("directmailgoodsorderaftersales.CreateTime not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNull() {
            addCriterion("directmailgoodsorderaftersales.UpdateUser is null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNotNull() {
            addCriterion("directmailgoodsorderaftersales.UpdateUser is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserEqualTo(String value) {
            addCriterion("directmailgoodsorderaftersales.UpdateUser =", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.UpdateUser = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotEqualTo(String value) {
            addCriterion("directmailgoodsorderaftersales.UpdateUser <>", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.UpdateUser <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThan(String value) {
            addCriterion("directmailgoodsorderaftersales.UpdateUser >", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.UpdateUser > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanOrEqualTo(String value) {
            addCriterion("directmailgoodsorderaftersales.UpdateUser >=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanOrEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.UpdateUser >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThan(String value) {
            addCriterion("directmailgoodsorderaftersales.UpdateUser <", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.UpdateUser < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanOrEqualTo(String value) {
            addCriterion("directmailgoodsorderaftersales.UpdateUser <=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanOrEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.UpdateUser <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLike(String value) {
            addCriterion("directmailgoodsorderaftersales.UpdateUser like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotLike(String value) {
            addCriterion("directmailgoodsorderaftersales.UpdateUser not like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIn(List<String> values) {
            addCriterion("directmailgoodsorderaftersales.UpdateUser in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotIn(List<String> values) {
            addCriterion("directmailgoodsorderaftersales.UpdateUser not in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserBetween(String value1, String value2) {
            addCriterion("directmailgoodsorderaftersales.UpdateUser between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotBetween(String value1, String value2) {
            addCriterion("directmailgoodsorderaftersales.UpdateUser not between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("directmailgoodsorderaftersales.UpdateTime is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("directmailgoodsorderaftersales.UpdateTime is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("directmailgoodsorderaftersales.UpdateTime =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.UpdateTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("directmailgoodsorderaftersales.UpdateTime <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.UpdateTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("directmailgoodsorderaftersales.UpdateTime >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.UpdateTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("directmailgoodsorderaftersales.UpdateTime >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.UpdateTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("directmailgoodsorderaftersales.UpdateTime <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.UpdateTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("directmailgoodsorderaftersales.UpdateTime <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualToColumn(DirectMailGoodsOrderAfterSales.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderaftersales.UpdateTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("directmailgoodsorderaftersales.UpdateTime in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("directmailgoodsorderaftersales.UpdateTime not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("directmailgoodsorderaftersales.UpdateTime between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("directmailgoodsorderaftersales.UpdateTime not between", value1, value2, "updateTime");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {
        private DirectMailGoodsOrderAfterSalesExample example;

        protected Criteria(DirectMailGoodsOrderAfterSalesExample example) {
            super();
            this.example = example;
        }

        public DirectMailGoodsOrderAfterSalesExample example() {
            return this.example;
        }

        @Deprecated
        public Criteria andIf(boolean ifAdd, ICriteriaAdd add) {
            if (ifAdd) {
                add.add(this);
            }
            return this;
        }

        public Criteria when(boolean condition, ICriteriaWhen then) {
            if (condition) {
                then.criteria(this);
            }
            return this;
        }

        public Criteria when(boolean condition, ICriteriaWhen then, ICriteriaWhen otherwise) {
            if (condition) {
                then.criteria(this);
            } else {
                otherwise.criteria(this);
            }
            return this;
        }

        public Criteria andLogicalDeleted(boolean deleted) {
            return deleted ? andDeletedEqualTo(DirectMailGoodsOrderAfterSales.Deleted.IS_DELETED.value()) : andDeletedNotEqualTo(DirectMailGoodsOrderAfterSales.Deleted.IS_DELETED.value());
        }

        @Deprecated
        public interface ICriteriaAdd {
            Criteria add(Criteria add);
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }

    public interface ICriteriaWhen {
        void criteria(Criteria criteria);
    }

    public interface IExampleWhen {
        void example(com.ecoolex.chinadutyfree.retailer.entity.DirectMailGoodsOrderAfterSalesExample example);
    }
}